package com.hunlian.makelove.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class CommonSqlite extends SQLiteOpenHelper{

	public CommonSqlite(Context context) {
		super(context, "commoncontent.db", null, 1);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL("CREATE TABLE commonptwop(id INTEGER PRIMARY KEY AUTOINCREMENT,platno VARCHAR(100),platname VARCHAR(100),platsite VARCHAR(100),num INT(100))");
		db.execSQL("CREATE TABLE commondc(id INTEGER PRIMARY KEY AUTOINCREMENT,bankcode VARCHAR(100),bankname VARCHAR(100),zhpinyin VARCHAR(100),num INT(100))");
		db.execSQL("CREATE TABLE commonyhlc(id INTEGER PRIMARY KEY AUTOINCREMENT,bankcode VARCHAR(100),bankname VARCHAR(100),zhpinyin VARCHAR(100),num INT(100))");
		db.execSQL("CREATE TABLE commonyeb(id INTEGER PRIMARY KEY AUTOINCREMENT,babyname VARCHAR(100),fundname VARCHAR(100),fundcode VARCHAR(100),zhpinyin VARCHAR(100),num INT(100),ishot VARCHAR(100))");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		
	}

}
